﻿-- =============================================
-- Author:		<Author,XFL>
-- Edit date: <Create Date,2012 02 03>
-- Description:	<Description, 添加 电汇账号 修改原有默认公司 为 指定公司
-- =============================================

CREATE PROCEDURE [dbo].[proc_Finance_Bank_Create]
	(
		@CompanyId int,
		@TypeId int,
		@InitialMoney numeric(18,2),
		@OpenBank nvarchar(50),
		@AccountName nvarchar(50),
		@AccountCartId nvarchar(50),
		@CreateDate datetime,
		@UserName nvarchar(50),
		@PaymentTypeName nvarchar(50),
		@PaymentTypeId int
	)
AS
begin
--	declare @CompanyId int
--	Select @CompanyId=CompanyId From Employee Where UserName=@UserName

	Insert Into Finance_Bank
		(TypeId,InitialMoney,CompanyId,OpenBank,AccountName,AccountCartId,CreateDate,UserName,PaymentTypeId,
		PaymentTypeName)
		Values
		(@TypeId,@InitialMoney,@CompanyId,@OpenBank,@AccountName,@AccountCartId,@CreateDate,@UserName,@PaymentTypeId,@PaymentTypeName)
end
	RETURN

